microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 36

To add two cells (A1 and A2) together you use the following formula

a) =A1 + A2

b) =Add(AI+A2)

c) together (A 1:A2)

d) AlplusA2

e) None of these

Answer: (a)

Question : 37

In Excel 3-D reference in a formula

a) Cannot be modified

b) Only appears on summary worksheets

c) Limits the formatting options

d) Spans worksheets

Answer: (d)

Question : 38

Excel uniquely identifies cells within a worksheet with a cell name

a) Cell names

b) Column numbers and row letters

c) Column letters and row numbers

d) Cell locator coordinates

e) None of these

Answer: (c)

Question : 39

The Paste Special command lets you copy and paste:

a) Multiply the selection by a copied value

b) Cell comments

c) Formatting options

d) The resulting values of a formula instead of the actual formula

e) None of these

Answer: (d)

Question : 40

Files created with Lotus 1-2-3 have an extension

a) DOC

b) XLS

c) 123

d) WK1

e) None of these

Answer: (c)

IMPORTANT computer mcq EXERCISES

microsoft excel q/a Shortcuts »

Click to Read...

MS excel set 5 Online Quiz

Click to Start..
369 microsoft excel qa based computer MCQ MS excel set 5 question answer with explanation pdf

Recently Added Subject & Categories For All Competitive Exams

100+ Quadratic Equation Questions Answers PDF for Bank

Quadratic Equation multiple choice questions with detailed answers for IBPS RRB SO. more than 250 Attitude practice test exercises for all competitive exams

03-Jul-2024 by Careericons

Continue Reading »

IBPS Aptitude Linear Equations MCQ Questions Answers PDF

Linear equations multiple choice questions with detailed answers for IBPS RRB SO. more than 250 Attitude practice test exercises for all competitive exams

03-Jul-2024 by Careericons

Continue Reading »

New 100+ Compound Interest MCQ with Answers PDF for IBPS

Compound Interest verbal ability questions and answers solutions with PDF for IBPS RRB PO. Aptitude Objective MCQ Practice Exercises all competitive exams

02-Jul-2024 by Careericons

Continue Reading »

100+ Mixture and Alligation MCQ Questions PDF for IBPS

Most importantly Mixture and Alligation multiple choice questions and answers with PDF for IBPS RRB PO. Aptitude MCQ Practice Exercises all Bank Exams

02-Jul-2024 by Careericons

Continue Reading »